/*
 资源管理模块数据库表结构

 Source Server Type    : MySQL
 Source Server Version : 80200 (8.2.0)
 Target Server Type    : MySQL
 File Encoding         : 65001

 Date: 2025-11-07
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for resource_material
-- ----------------------------
DROP TABLE IF EXISTS `resource_material`;
CREATE TABLE `resource_material` (
  `id` BIGINT NOT NULL AUTO_INCREMENT COMMENT '资源ID',
  `title` VARCHAR(100) NOT NULL COMMENT '资源标题',
  `description` VARCHAR(500) DEFAULT NULL COMMENT '资源描述',
  `type` TINYINT NOT NULL COMMENT '资源类型：1-头像 2-图片 3-壁纸',
  `thumbnail_url` VARCHAR(500) NOT NULL COMMENT '缩略图URL',
  `original_url` VARCHAR(500) NOT NULL COMMENT '原图URL',
  `file_size` BIGINT DEFAULT NULL COMMENT '文件大小（字节）',
  `width` INT DEFAULT NULL COMMENT '图片宽度（像素）',
  `height` INT DEFAULT NULL COMMENT '图片高度（像素）',
  `is_free` TINYINT DEFAULT 1 COMMENT '是否免费：0-付费 1-免费',
  `download_count` INT DEFAULT 0 COMMENT '下载次数',
  `collect_count` INT DEFAULT 0 COMMENT '收藏次数',
  `view_count` INT DEFAULT 0 COMMENT '浏览次数',
  `creator_id` BIGINT NOT NULL COMMENT '创作者ID',
  `status` TINYINT DEFAULT 0 COMMENT '状态：0-待审核 1-已发布 2-已下架',
  `audit_remark` VARCHAR(500) DEFAULT NULL COMMENT '审核备注',
  `creator` VARCHAR(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '创建者',
  `create_time` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updater` VARCHAR(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '更新者',
  `update_time` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `deleted` BIT(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
  `tenant_id` BIGINT NOT NULL DEFAULT 0 COMMENT '租户ID',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `idx_creator_id` (`creator_id`) USING BTREE,
  INDEX `idx_type_status` (`type`, `status`) USING BTREE,
  INDEX `idx_create_time` (`create_time`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='资源表';

-- ----------------------------
-- Table structure for resource_category
-- ----------------------------
DROP TABLE IF EXISTS `resource_category`;
CREATE TABLE `resource_category` (
  `id` BIGINT NOT NULL AUTO_INCREMENT COMMENT '分类ID',
  `parent_id` BIGINT DEFAULT 0 COMMENT '父分类ID，0表示顶级分类',
  `name` VARCHAR(50) NOT NULL COMMENT '分类名称',
  `sort` INT DEFAULT 0 COMMENT '排序',
  `icon` VARCHAR(500) DEFAULT NULL COMMENT '图标URL',
  `status` TINYINT DEFAULT 1 COMMENT '状态：0-禁用 1-启用',
  `creator` VARCHAR(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '创建者',
  `create_time` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updater` VARCHAR(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '更新者',
  `update_time` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `deleted` BIT(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
  `tenant_id` BIGINT NOT NULL DEFAULT 0 COMMENT '租户ID',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `idx_parent_id` (`parent_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='分类表';

-- ----------------------------
-- Table structure for resource_tag
-- ----------------------------
DROP TABLE IF EXISTS `resource_tag`;
CREATE TABLE `resource_tag` (
  `id` BIGINT NOT NULL AUTO_INCREMENT COMMENT '标签ID',
  `name` VARCHAR(50) NOT NULL COMMENT '标签名称',
  `color` VARCHAR(20) DEFAULT NULL COMMENT '标签颜色',
  `sort` INT DEFAULT 0 COMMENT '排序',
  `usage_count` INT DEFAULT 0 COMMENT '使用次数',
  `creator` VARCHAR(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '创建者',
  `create_time` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updater` VARCHAR(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '更新者',
  `update_time` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `deleted` BIT(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
  `tenant_id` BIGINT NOT NULL DEFAULT 0 COMMENT '租户ID',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `uk_name` (`name`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='标签表';

-- ----------------------------
-- Table structure for resource_category_relation
-- ----------------------------
DROP TABLE IF EXISTS `resource_category_relation`;
CREATE TABLE `resource_category_relation` (
  `id` BIGINT NOT NULL AUTO_INCREMENT COMMENT '关联ID',
  `material_id` BIGINT NOT NULL COMMENT '资源ID',
  `category_id` BIGINT NOT NULL COMMENT '分类ID',
  `creator` VARCHAR(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '创建者',
  `create_time` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updater` VARCHAR(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '更新者',
  `update_time` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `deleted` BIT(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
  `tenant_id` BIGINT NOT NULL DEFAULT 0 COMMENT '租户ID',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `uk_material_category` (`material_id`, `category_id`) USING BTREE,
  INDEX `idx_category_id` (`category_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='资源分类关联表';

-- ----------------------------
-- Table structure for resource_tag_relation
-- ----------------------------
DROP TABLE IF EXISTS `resource_tag_relation`;
CREATE TABLE `resource_tag_relation` (
  `id` BIGINT NOT NULL AUTO_INCREMENT COMMENT '关联ID',
  `material_id` BIGINT NOT NULL COMMENT '资源ID',
  `tag_id` BIGINT NOT NULL COMMENT '标签ID',
  `creator` VARCHAR(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '创建者',
  `create_time` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updater` VARCHAR(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '更新者',
  `update_time` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `deleted` BIT(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
  `tenant_id` BIGINT NOT NULL DEFAULT 0 COMMENT '租户ID',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `uk_material_tag` (`material_id`, `tag_id`) USING BTREE,
  INDEX `idx_tag_id` (`tag_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='资源标签关联表';

-- ----------------------------
-- Table structure for resource_creator
-- ----------------------------
DROP TABLE IF EXISTS `resource_creator`;
CREATE TABLE `resource_creator` (
  `id` BIGINT NOT NULL AUTO_INCREMENT COMMENT '创作者ID',
  `user_id` BIGINT NOT NULL COMMENT '用户ID（关联system_users）',
  `nickname` VARCHAR(100) NOT NULL COMMENT '创作者昵称',
  `avatar` VARCHAR(500) DEFAULT NULL COMMENT '头像URL',
  `introduction` VARCHAR(500) DEFAULT NULL COMMENT '简介',
  `status` TINYINT DEFAULT 0 COMMENT '状态：0-待审核 1-正常 2-禁用',
  `audit_status` TINYINT DEFAULT 0 COMMENT '审核状态：0-待审核 1-通过 2-拒绝',
  `audit_remark` VARCHAR(500) DEFAULT NULL COMMENT '审核备注',
  `total_points` INT DEFAULT 0 COMMENT '总积分',
  `available_points` INT DEFAULT 0 COMMENT '可用积分',
  `material_count` INT DEFAULT 0 COMMENT '资源数量',
  `follower_count` INT DEFAULT 0 COMMENT '粉丝数量',
  `creator` VARCHAR(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '创建者',
  `create_time` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updater` VARCHAR(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '更新者',
  `update_time` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `deleted` BIT(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
  `tenant_id` BIGINT NOT NULL DEFAULT 0 COMMENT '租户ID',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `uk_user_id` (`user_id`) USING BTREE,
  INDEX `idx_status` (`status`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='创作者表';

-- ----------------------------
-- Table structure for resource_advertiser
-- ----------------------------
DROP TABLE IF EXISTS `resource_advertiser`;
CREATE TABLE `resource_advertiser` (
  `id` BIGINT NOT NULL AUTO_INCREMENT COMMENT '广告商ID',
  `user_id` BIGINT NOT NULL COMMENT '用户ID（关联system_users）',
  `company_name` VARCHAR(200) NOT NULL COMMENT '公司名称',
  `contact_person` VARCHAR(100) NOT NULL COMMENT '联系人',
  `contact_phone` VARCHAR(20) NOT NULL COMMENT '联系电话',
  `business_license` VARCHAR(500) DEFAULT NULL COMMENT '营业执照URL',
  `status` TINYINT DEFAULT 0 COMMENT '状态：0-待审核 1-正常 2-禁用',
  `audit_status` TINYINT DEFAULT 0 COMMENT '审核状态：0-待审核 1-通过 2-拒绝',
  `audit_remark` VARCHAR(500) DEFAULT NULL COMMENT '审核备注',
  `creator` VARCHAR(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '创建者',
  `create_time` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updater` VARCHAR(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '更新者',
  `update_time` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `deleted` BIT(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
  `tenant_id` BIGINT NOT NULL DEFAULT 0 COMMENT '租户ID',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `uk_user_id` (`user_id`) USING BTREE,
  INDEX `idx_status` (`status`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='广告商表';

-- ----------------------------
-- Table structure for resource_advertisement
-- ----------------------------
DROP TABLE IF EXISTS `resource_advertisement`;
CREATE TABLE `resource_advertisement` (
  `id` BIGINT NOT NULL AUTO_INCREMENT COMMENT '广告ID',
  `advertiser_id` BIGINT NOT NULL COMMENT '广告商ID',
  `title` VARCHAR(200) NOT NULL COMMENT '广告标题',
  `type` TINYINT DEFAULT 1 COMMENT '广告类型：1-激励视频 2-Banner',
  `video_url` VARCHAR(500) DEFAULT NULL COMMENT '视频URL（激励视频）',
  `duration` INT DEFAULT NULL COMMENT '视频时长（秒）',
  `click_url` VARCHAR(500) DEFAULT NULL COMMENT '点击跳转URL',
  `status` TINYINT DEFAULT 0 COMMENT '状态：0-待审核 1-投放中 2-已暂停 3-已结束',
  `start_time` DATETIME DEFAULT NULL COMMENT '开始时间',
  `end_time` DATETIME DEFAULT NULL COMMENT '结束时间',
  `daily_budget` DECIMAL(10,2) DEFAULT NULL COMMENT '日预算（元）',
  `total_budget` DECIMAL(10,2) DEFAULT NULL COMMENT '总预算（元）',
  `view_count` INT DEFAULT 0 COMMENT '观看次数',
  `click_count` INT DEFAULT 0 COMMENT '点击次数',
  `creator` VARCHAR(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '创建者',
  `create_time` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updater` VARCHAR(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '更新者',
  `update_time` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `deleted` BIT(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
  `tenant_id` BIGINT NOT NULL DEFAULT 0 COMMENT '租户ID',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `idx_advertiser_id` (`advertiser_id`) USING BTREE,
  INDEX `idx_status_time` (`status`, `start_time`, `end_time`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='广告表';

-- ----------------------------
-- Table structure for resource_points_record
-- ----------------------------
DROP TABLE IF EXISTS `resource_points_record`;
CREATE TABLE `resource_points_record` (
  `id` BIGINT NOT NULL AUTO_INCREMENT COMMENT '记录ID',
  `creator_id` BIGINT NOT NULL COMMENT '创作者ID',
  `type` TINYINT NOT NULL COMMENT '类型：1-入驻 2-上传资源 3-资源被收藏 4-资源被下载',
  `points` INT NOT NULL COMMENT '积分变动（正数为增加，负数为减少）',
  `balance` INT NOT NULL COMMENT '变动后余额',
  `business_id` BIGINT DEFAULT NULL COMMENT '业务ID（资源ID等）',
  `description` VARCHAR(200) DEFAULT NULL COMMENT '描述',
  `creator` VARCHAR(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '创建者',
  `create_time` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updater` VARCHAR(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '更新者',
  `update_time` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `deleted` BIT(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
  `tenant_id` BIGINT NOT NULL DEFAULT 0 COMMENT '租户ID',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `idx_creator_id_time` (`creator_id`, `create_time`) USING BTREE,
  INDEX `idx_type` (`type`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='积分记录表';

-- ----------------------------
-- Table structure for resource_collect
-- ----------------------------
DROP TABLE IF EXISTS `resource_collect`;
CREATE TABLE `resource_collect` (
  `id` BIGINT NOT NULL AUTO_INCREMENT COMMENT '收藏ID',
  `user_id` BIGINT NOT NULL COMMENT '用户ID',
  `material_id` BIGINT NOT NULL COMMENT '资源ID',
  `creator` VARCHAR(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '创建者',
  `create_time` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updater` VARCHAR(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '更新者',
  `update_time` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `deleted` BIT(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
  `tenant_id` BIGINT NOT NULL DEFAULT 0 COMMENT '租户ID',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `uk_user_material` (`user_id`, `material_id`) USING BTREE,
  INDEX `idx_material_id` (`material_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='用户收藏表';

-- ----------------------------
-- Table structure for resource_download
-- ----------------------------
DROP TABLE IF EXISTS `resource_download`;
CREATE TABLE `resource_download` (
  `id` BIGINT NOT NULL AUTO_INCREMENT COMMENT '下载ID',
  `user_id` BIGINT NOT NULL COMMENT '用户ID',
  `material_id` BIGINT NOT NULL COMMENT '资源ID',
  `ad_id` BIGINT DEFAULT NULL COMMENT '观看的广告ID（付费资源）',
  `is_free` TINYINT DEFAULT 1 COMMENT '是否免费下载：0-付费 1-免费',
  `creator` VARCHAR(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '创建者',
  `create_time` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updater` VARCHAR(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '更新者',
  `update_time` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `deleted` BIT(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
  `tenant_id` BIGINT NOT NULL DEFAULT 0 COMMENT '租户ID',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `idx_user_material` (`user_id`, `material_id`) USING BTREE,
  INDEX `idx_material_time` (`material_id`, `create_time`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='下载记录表';

-- ----------------------------
-- Records and initial data
-- ----------------------------
BEGIN;

-- 初始化分类数据
INSERT INTO `resource_category` (`id`, `parent_id`, `name`, `sort`, `icon`, `status`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `tenant_id`) VALUES
(1, 0, '头像', 1, NULL, 1, 'admin', NOW(), 'admin', NOW(), b'0', 0),
(2, 0, '图片', 2, NULL, 1, 'admin', NOW(), 'admin', NOW(), b'0', 0),
(3, 0, '壁纸', 3, NULL, 1, 'admin', NOW(), 'admin', NOW(), b'0', 0),
(11, 1, '男生头像', 1, NULL, 1, 'admin', NOW(), 'admin', NOW(), b'0', 0),
(12, 1, '女生头像', 2, NULL, 1, 'admin', NOW(), 'admin', NOW(), b'0', 0),
(13, 1, '动漫头像', 3, NULL, 1, 'admin', NOW(), 'admin', NOW(), b'0', 0),
(14, 1, '情侣头像', 4, NULL, 1, 'admin', NOW(), 'admin', NOW(), b'0', 0),
(21, 2, '风景图片', 1, NULL, 1, 'admin', NOW(), 'admin', NOW(), b'0', 0),
(22, 2, '人物图片', 2, NULL, 1, 'admin', NOW(), 'admin', NOW(), b'0', 0),
(23, 2, '动物图片', 3, NULL, 1, 'admin', NOW(), 'admin', NOW(), b'0', 0),
(31, 3, '手机壁纸', 1, NULL, 1, 'admin', NOW(), 'admin', NOW(), b'0', 0),
(32, 3, '电脑壁纸', 2, NULL, 1, 'admin', NOW(), 'admin', NOW(), b'0', 0),
(33, 3, '高清壁纸', 3, NULL, 1, 'admin', NOW(), 'admin', NOW(), b'0', 0);

-- 初始化标签数据
INSERT INTO `resource_tag` (`id`, `name`, `color`, `sort`, `usage_count`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `tenant_id`) VALUES
(1, '清新', '#87CEEB', 1, 0, 'admin', NOW(), 'admin', NOW(), b'0', 0),
(2, '可爱', '#FFB6C1', 2, 0, 'admin', NOW(), 'admin', NOW(), b'0', 0),
(3, '酷炫', '#FF6347', 3, 0, 'admin', NOW(), 'admin', NOW(), b'0', 0),
(4, '唯美', '#DDA0DD', 4, 0, 'admin', NOW(), 'admin', NOW(), b'0', 0),
(5, '搞笑', '#FFD700', 5, 0, 'admin', NOW(), 'admin', NOW(), b'0', 0),
(6, '励志', '#32CD32', 6, 0, 'admin', NOW(), 'admin', NOW(), b'0', 0),
(7, '简约', '#808080', 7, 0, 'admin', NOW(), 'admin', NOW(), b'0', 0),
(8, '复古', '#8B4513', 8, 0, 'admin', NOW(), 'admin', NOW(), b'0', 0),
(9, '科技', '#4169E1', 9, 0, 'admin', NOW(), 'admin', NOW(), b'0', 0),
(10, '艺术', '#9370DB', 10, 0, 'admin', NOW(), 'admin', NOW(), b'0', 0);

COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
